﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsSalesByDis" targetNamespace="http://tempuri.org/dsSalesByDis.xsd" xmlns:mstns="http://tempuri.org/dsSalesByDis.xsd" xmlns="http://tempuri.org/dsSalesByDis.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="CarlsbergConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CarlsbergConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.CarlsbergConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sp_Display_Sales_By_DisTableAdapter" GeneratorDataComponentClassName="sp_Display_Sales_By_DisTableAdapter" Name="sp_Display_Sales_By_Dis" UserDataComponentName="sp_Display_Sales_By_DisTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CarlsbergConnectionString (Web.config)" DbObjectName="Carlsberg.dbo.sp_Display_Sales_By_Dis" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.sp_Display_Sales_By_Dis</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="DragonName" DataSetColumn="DragonName" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="Province" DataSetColumn="Province" />
              <Mapping SourceColumn="Owner" DataSetColumn="Owner" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Distributor" DataSetColumn="Distributor" />
              <Mapping SourceColumn="STT" DataSetColumn="STT" />
              <Mapping SourceColumn="BACode" DataSetColumn="BACode" />
              <Mapping SourceColumn="BACodeNS" DataSetColumn="BACodeNS" />
              <Mapping SourceColumn="BAName" DataSetColumn="BAName" />
              <Mapping SourceColumn="OutletCode" DataSetColumn="OutletCode" />
              <Mapping SourceColumn="OutletName" DataSetColumn="OutletName" />
              <Mapping SourceColumn="OutletAddress" DataSetColumn="OutletAddress" />
              <Mapping SourceColumn="WorkingDay" DataSetColumn="WorkingDay" />
              <Mapping SourceColumn="NoOfBA" DataSetColumn="NoOfBA" />
              <Mapping SourceColumn="GCi" DataSetColumn="GCi" />
              <Mapping SourceColumn="GBi" DataSetColumn="GBi" />
              <Mapping SourceColumn="CBi" DataSetColumn="CBi" />
              <Mapping SourceColumn="CCi" DataSetColumn="CCi" />
              <Mapping SourceColumn="CDi" DataSetColumn="CDi" />
              <Mapping SourceColumn="H3i" DataSetColumn="H3i" />
              <Mapping SourceColumn="H4i" DataSetColumn="H4i" />
              <Mapping SourceColumn="HCi" DataSetColumn="HCi" />
              <Mapping SourceColumn="GC" DataSetColumn="GC" />
              <Mapping SourceColumn="GB" DataSetColumn="GB" />
              <Mapping SourceColumn="CB" DataSetColumn="CB" />
              <Mapping SourceColumn="CC" DataSetColumn="CC" />
              <Mapping SourceColumn="CD" DataSetColumn="CD" />
              <Mapping SourceColumn="H3" DataSetColumn="H3" />
              <Mapping SourceColumn="H4" DataSetColumn="H4" />
              <Mapping SourceColumn="HC" DataSetColumn="HC" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsSalesByDis" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dsSalesByDis" msprop:Generator_UserDSName="dsSalesByDis">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="sp_Display_Sales_By_Dis" msprop:Generator_TableClassName="sp_Display_Sales_By_DisDataTable" msprop:Generator_TableVarName="tablesp_Display_Sales_By_Dis" msprop:Generator_RowChangedName="sp_Display_Sales_By_DisRowChanged" msprop:Generator_TablePropName="sp_Display_Sales_By_Dis" msprop:Generator_RowDeletingName="sp_Display_Sales_By_DisRowDeleting" msprop:Generator_RowChangingName="sp_Display_Sales_By_DisRowChanging" msprop:Generator_RowEvHandlerName="sp_Display_Sales_By_DisRowChangeEventHandler" msprop:Generator_RowDeletedName="sp_Display_Sales_By_DisRowDeleted" msprop:Generator_RowClassName="sp_Display_Sales_By_DisRow" msprop:Generator_UserTableName="sp_Display_Sales_By_Dis" msprop:Generator_RowEvArgName="sp_Display_Sales_By_DisRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnPropNameInTable="CodeColumn" msprop:Generator_UserColumnName="Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DragonName" msprop:Generator_ColumnVarNameInTable="columnDragonName" msprop:Generator_ColumnPropNameInRow="DragonName" msprop:Generator_ColumnPropNameInTable="DragonNameColumn" msprop:Generator_UserColumnName="DragonName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Province" msprop:Generator_ColumnVarNameInTable="columnProvince" msprop:Generator_ColumnPropNameInRow="Province" msprop:Generator_ColumnPropNameInTable="ProvinceColumn" msprop:Generator_UserColumnName="Province" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Owner" msprop:Generator_ColumnVarNameInTable="columnOwner" msprop:Generator_ColumnPropNameInRow="Owner" msprop:Generator_ColumnPropNameInTable="OwnerColumn" msprop:Generator_UserColumnName="Owner" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Distributor" msprop:Generator_ColumnVarNameInTable="columnDistributor" msprop:Generator_ColumnPropNameInRow="Distributor" msprop:Generator_ColumnPropNameInTable="DistributorColumn" msprop:Generator_UserColumnName="Distributor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STT" msprop:Generator_ColumnVarNameInTable="columnSTT" msprop:Generator_ColumnPropNameInRow="STT" msprop:Generator_ColumnPropNameInTable="STTColumn" msprop:Generator_UserColumnName="STT" type="xs:int" minOccurs="0" />
              <xs:element name="BACode" msprop:Generator_ColumnVarNameInTable="columnBACode" msprop:Generator_ColumnPropNameInRow="BACode" msprop:Generator_ColumnPropNameInTable="BACodeColumn" msprop:Generator_UserColumnName="BACode" type="xs:int" minOccurs="0" />
              <xs:element name="BACodeNS" msprop:Generator_ColumnVarNameInTable="columnBACodeNS" msprop:Generator_ColumnPropNameInRow="BACodeNS" msprop:Generator_ColumnPropNameInTable="BACodeNSColumn" msprop:Generator_UserColumnName="BACodeNS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BAName" msprop:Generator_ColumnVarNameInTable="columnBAName" msprop:Generator_ColumnPropNameInRow="BAName" msprop:Generator_ColumnPropNameInTable="BANameColumn" msprop:Generator_UserColumnName="BAName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletCode" msprop:Generator_ColumnVarNameInTable="columnOutletCode" msprop:Generator_ColumnPropNameInRow="OutletCode" msprop:Generator_ColumnPropNameInTable="OutletCodeColumn" msprop:Generator_UserColumnName="OutletCode" type="xs:int" minOccurs="0" />
              <xs:element name="OutletName" msprop:Generator_ColumnVarNameInTable="columnOutletName" msprop:Generator_ColumnPropNameInRow="OutletName" msprop:Generator_ColumnPropNameInTable="OutletNameColumn" msprop:Generator_UserColumnName="OutletName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OutletAddress" msprop:Generator_ColumnVarNameInTable="columnOutletAddress" msprop:Generator_ColumnPropNameInRow="OutletAddress" msprop:Generator_ColumnPropNameInTable="OutletAddressColumn" msprop:Generator_UserColumnName="OutletAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkingDay" msprop:Generator_ColumnVarNameInTable="columnWorkingDay" msprop:Generator_ColumnPropNameInRow="WorkingDay" msprop:Generator_ColumnPropNameInTable="WorkingDayColumn" msprop:Generator_UserColumnName="WorkingDay" type="xs:int" minOccurs="0" />
              <xs:element name="NoOfBA" msprop:Generator_ColumnVarNameInTable="columnNoOfBA" msprop:Generator_ColumnPropNameInRow="NoOfBA" msprop:Generator_ColumnPropNameInTable="NoOfBAColumn" msprop:Generator_UserColumnName="NoOfBA" type="xs:int" minOccurs="0" />
              <xs:element name="GCi" msprop:Generator_ColumnVarNameInTable="columnGCi" msprop:Generator_ColumnPropNameInRow="GCi" msprop:Generator_ColumnPropNameInTable="GCiColumn" msprop:Generator_UserColumnName="GCi" type="xs:int" minOccurs="0" />
              <xs:element name="GBi" msprop:Generator_ColumnVarNameInTable="columnGBi" msprop:Generator_ColumnPropNameInRow="GBi" msprop:Generator_ColumnPropNameInTable="GBiColumn" msprop:Generator_UserColumnName="GBi" type="xs:int" minOccurs="0" />
              <xs:element name="CBi" msprop:Generator_ColumnVarNameInTable="columnCBi" msprop:Generator_ColumnPropNameInRow="CBi" msprop:Generator_ColumnPropNameInTable="CBiColumn" msprop:Generator_UserColumnName="CBi" type="xs:int" minOccurs="0" />
              <xs:element name="CCi" msprop:Generator_ColumnVarNameInTable="columnCCi" msprop:Generator_ColumnPropNameInRow="CCi" msprop:Generator_ColumnPropNameInTable="CCiColumn" msprop:Generator_UserColumnName="CCi" type="xs:int" minOccurs="0" />
              <xs:element name="CDi" msprop:Generator_ColumnVarNameInTable="columnCDi" msprop:Generator_ColumnPropNameInRow="CDi" msprop:Generator_ColumnPropNameInTable="CDiColumn" msprop:Generator_UserColumnName="CDi" type="xs:int" minOccurs="0" />
              <xs:element name="H3i" msprop:Generator_ColumnVarNameInTable="columnH3i" msprop:Generator_ColumnPropNameInRow="H3i" msprop:Generator_ColumnPropNameInTable="H3iColumn" msprop:Generator_UserColumnName="H3i" type="xs:int" minOccurs="0" />
              <xs:element name="H4i" msprop:Generator_ColumnVarNameInTable="columnH4i" msprop:Generator_ColumnPropNameInRow="H4i" msprop:Generator_ColumnPropNameInTable="H4iColumn" msprop:Generator_UserColumnName="H4i" type="xs:int" minOccurs="0" />
              <xs:element name="HCi" msprop:Generator_ColumnVarNameInTable="columnHCi" msprop:Generator_ColumnPropNameInRow="HCi" msprop:Generator_ColumnPropNameInTable="HCiColumn" msprop:Generator_UserColumnName="HCi" type="xs:int" minOccurs="0" />
              <xs:element name="GC" msprop:Generator_ColumnVarNameInTable="columnGC" msprop:Generator_ColumnPropNameInRow="GC" msprop:Generator_ColumnPropNameInTable="GCColumn" msprop:Generator_UserColumnName="GC" type="xs:int" minOccurs="0" />
              <xs:element name="GB" msprop:Generator_ColumnVarNameInTable="columnGB" msprop:Generator_ColumnPropNameInRow="GB" msprop:Generator_ColumnPropNameInTable="GBColumn" msprop:Generator_UserColumnName="GB" type="xs:int" minOccurs="0" />
              <xs:element name="CB" msprop:Generator_ColumnVarNameInTable="columnCB" msprop:Generator_ColumnPropNameInRow="CB" msprop:Generator_ColumnPropNameInTable="CBColumn" msprop:Generator_UserColumnName="CB" type="xs:int" minOccurs="0" />
              <xs:element name="CC" msprop:Generator_ColumnVarNameInTable="columnCC" msprop:Generator_ColumnPropNameInRow="CC" msprop:Generator_ColumnPropNameInTable="CCColumn" msprop:Generator_UserColumnName="CC" type="xs:int" minOccurs="0" />
              <xs:element name="CD" msprop:Generator_ColumnVarNameInTable="columnCD" msprop:Generator_ColumnPropNameInRow="CD" msprop:Generator_ColumnPropNameInTable="CDColumn" msprop:Generator_UserColumnName="CD" type="xs:int" minOccurs="0" />
              <xs:element name="H3" msprop:Generator_ColumnVarNameInTable="columnH3" msprop:Generator_ColumnPropNameInRow="H3" msprop:Generator_ColumnPropNameInTable="H3Column" msprop:Generator_UserColumnName="H3" type="xs:int" minOccurs="0" />
              <xs:element name="H4" msprop:Generator_ColumnVarNameInTable="columnH4" msprop:Generator_ColumnPropNameInRow="H4" msprop:Generator_ColumnPropNameInTable="H4Column" msprop:Generator_UserColumnName="H4" type="xs:int" minOccurs="0" />
              <xs:element name="HC" msprop:Generator_ColumnVarNameInTable="columnHC" msprop:Generator_ColumnPropNameInRow="HC" msprop:Generator_ColumnPropNameInTable="HCColumn" msprop:Generator_UserColumnName="HC" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:sp_Display_Sales_By_Dis" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
  </xs:element>
</xs:schema>